﻿
-- =============================================
CREATE PROCEDURE TopLists

AS
BEGIN
select top 10 l.Title,l.ItemCount,l.Size, l.URL
from SharePointOptimizer.dbo.List  l
order by l.Size desc
END